engage in the work of online information collection, the most headaches is the first time from the same web site is very boring to copy the data table, and even after copying over a lot of changes is not only cumbersome but also is also a waste of time and greatly reduced efficiency. We may wish to use this powerful Excel to try to solve the problem. In this paper, the HTTP proxy in accordance with commonly used data extraction for example, describes how to use EXCEL data into a standardized form.

a fairly standard form for data, we can in the table right-click page, select "Export to Microsoft Office Excel" (Figure 1), when the system will automatically open the Office Excel, data load. This process took only a few seconds to load into the data (Figure 2). If you think the data are more suitable for editing your requirements, it can be saved directly. Otherwise, you can do the appropriate changes, because treatment in the table, Excel is much better than the word.

Figure 1

online forms or data collection on this point, Excel is often more intelligent, which during the data collection and load, only load the form of fixed data in the region, rather than the whole page to load in. . I tried many times, are very obedient, see picture 2 results.

Figure 2

Of course, in the pages do not regulate some forms of data, such data, Excel to deal with a little bit difficult, but as long as familiar with the Excel function of the operation, or can easily get the. Look at this page (Figure 3),

Figure 3